UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zxCC+b+7CggEoY16dsm3ewpnIJWlAHa0/BiMyKAvoHU='
WHERE
key_id = '63720f40d4028fc12dac12ba3acb42ce81cea60be87fec7d64514d0abb608348'
AND (
token = 'zxCC+b+7CggEoY16dsm3ewpnIJWlAHa0/BiMyKAvoHU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)