UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xA7L0k4lqVf0+3PgT6E1ilsQxRVPHF5kJU/fNHttc9o='
WHERE
key_id = 'e62e78a5f22b64b831a9e2e991a4bf7153009bd1993f4bc563020426c368cb33'
AND (
token = 'xA7L0k4lqVf0+3PgT6E1ilsQxRVPHF5kJU/fNHttc9o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)