UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g3J52exV3uFDqbqxLyw+xrp7Y6BGyGrBSP2Gv7L7xvE='
WHERE
key_id = '6a4f9b4fe437056ffca7e614249cbc09b9a5bb911fa6ddc3407f6f2fdd4ed8cb'
AND (
token = 'g3J52exV3uFDqbqxLyw+xrp7Y6BGyGrBSP2Gv7L7xvE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)