UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0iRjLWcTkDHm3QiroQDTk7Hvjq7m4uvdQjiwwgB6ftc='
WHERE
key_id = 'f2f339e6c3962ec3eb55933870cc8c15ca4509e579d5afaa3103674c8a6e3153'
AND (
token = '0iRjLWcTkDHm3QiroQDTk7Hvjq7m4uvdQjiwwgB6ftc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)