UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2OEbhiODz9nmY3EzzEqYyc4lY+oLgn+EAZnKuxjsg44='
WHERE
key_id = '00bc6701750b99865458a22b4f8b978328af4a442fc29eab4b797a37de370a67'
AND (
token = '2OEbhiODz9nmY3EzzEqYyc4lY+oLgn+EAZnKuxjsg44='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)