UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JFeBmGeEFzCdvSGN1WhoVtgGzf1oWI6xLkESvCNwJgU='
WHERE
key_id = '7714a87826b341c69d2a80d3c86c2159c1400f2734c95dc0c0ce6137ac9fd7a1'
AND (
token = 'JFeBmGeEFzCdvSGN1WhoVtgGzf1oWI6xLkESvCNwJgU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)