UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fyf0NSqJTJ8YbpDXMLBiyFa8ke5pnRc8wglVgrka0nw='
WHERE
key_id = '27f405872bddd3e3c4b3db9ebcecbc23842b8da3d98d60159636e0780de7772f'
AND (
token = 'fyf0NSqJTJ8YbpDXMLBiyFa8ke5pnRc8wglVgrka0nw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)