UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CgcZV9sKNg9hnnC36PLQ2KzJoLiXIWdmVJFkj2R4POI='
WHERE
key_id = '2f10b5b5a93c1766a9de54e393798fbec2eb53ff513387afcf55d2a1c9730d22'
AND (
token = 'CgcZV9sKNg9hnnC36PLQ2KzJoLiXIWdmVJFkj2R4POI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)