UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lUVIIvotM6TeDjv1hKgHmnmbV8EUOFhMOTXdjcCrsgA='
WHERE
key_id = 'bbce65b69b7f10cad4480b1dd78869e454b8344ca14c745219ffec33288fddef'
AND (
token = 'lUVIIvotM6TeDjv1hKgHmnmbV8EUOFhMOTXdjcCrsgA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)