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