UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nGfb0xu2gXqHPKD9PX4q1KTjuVHIEVu9BpfiPV48ahA='
WHERE
key_id = '9bfd0b32f1ce870e3761b79d7b45ef47a5a2ce8d448eb9e4c3d0bd5fc3ca26ec'
AND (
token = 'nGfb0xu2gXqHPKD9PX4q1KTjuVHIEVu9BpfiPV48ahA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)