UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cNr7G+ih9L3l9JHNCF8yuV5ZnFnfSY6x+3kKgy9/8C4='
WHERE
key_id = '3a8f42612138ecb616966673dac29e302dadfe8e4f44c41e6e684d70068b4554'
AND (
token = 'cNr7G+ih9L3l9JHNCF8yuV5ZnFnfSY6x+3kKgy9/8C4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)