UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hw1zMiiJlK4teNrS4eSR2Agy9yTJgXsJ7ILPyII+KYg='
WHERE
key_id = '467d269921bb2c5351b3bc88537d035460ef1f38d59e3920b346b2957092057c'
AND (
token = 'Hw1zMiiJlK4teNrS4eSR2Agy9yTJgXsJ7ILPyII+KYg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)