UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eSBQQPRglX3wHcjfC2nmcMI3AAUItUA/ZAf+YYwi3Hw='
WHERE
key_id = '6c6d332b3c89e68bad19d6462da569e853160b0bbb2c27ad78100b3c255d2882'
AND (
token = 'eSBQQPRglX3wHcjfC2nmcMI3AAUItUA/ZAf+YYwi3Hw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)