UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xli44rcYRGFn065bw7at5rJl0xojQ9iFj8tut4Ulm24='
WHERE
key_id = '20f1540ea0be362475e9e819c9c21ef0aa3a4004d5d4dd5372f07ca74d8bd87d'
AND (
token = 'xli44rcYRGFn065bw7at5rJl0xojQ9iFj8tut4Ulm24='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)