UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lhVXHrrXv8V70ZOXEWgT+fcGYxYmPXbkA11pzlJH+m0='
WHERE
key_id = '997b0e6d9dcaf0185a9cdf9d311169690edbc95d2aba02a5bf2e226e44cee9a3'
AND (
token = 'lhVXHrrXv8V70ZOXEWgT+fcGYxYmPXbkA11pzlJH+m0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)