UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yz+Nv/Clk18lkT5gCe4s3IW0sRtD4HkzgMEXivhXs7Q='
WHERE
key_id = '0a6d2a8d872fddad798223ae32ea7538e8af79beef66473b539922c2f629a8bf'
AND (
token = 'yz+Nv/Clk18lkT5gCe4s3IW0sRtD4HkzgMEXivhXs7Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)