UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3hMJFGWV7UkBwHsk9Nk07NH/8J/TMG+9TPgHImGNaiU='
WHERE
key_id = '4953a49e1c0d0679f9dd78104749f999ab5650920e945028d701886d4a19dbea'
AND (
token = '3hMJFGWV7UkBwHsk9Nk07NH/8J/TMG+9TPgHImGNaiU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)