UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ji8hHu+BdVRcxUjGFV0mElw7v51CtT7App4qN9Is8Yw='
WHERE
key_id = '9d0ff60a6388ef04f38ec141ebbabb2361d31c04c9aebf840e551909a32e10f7'
AND (
token = 'Ji8hHu+BdVRcxUjGFV0mElw7v51CtT7App4qN9Is8Yw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)