UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YcsHiL53tl4sz5mek7ojA907MRcF0yp+omVTq1U+CIY='
WHERE
key_id = '6de02ba5c165b9c4bd91522ffe0cdd756303b76e36f7aa42e0faea8de0c2425b'
AND (
token = 'YcsHiL53tl4sz5mek7ojA907MRcF0yp+omVTq1U+CIY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)