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