UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fQWrRJPrDdZX1OtPYZJIrGNuo4MfmckOyQVCz9yJYU8='
WHERE
key_id = '87f292cd2b50d2bd15a20a92c27dcdd4aad86140b51feedef8f2c2fb6d7544c9'
AND (
token = 'fQWrRJPrDdZX1OtPYZJIrGNuo4MfmckOyQVCz9yJYU8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)