UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lqNCUn8Z4v+OPJEERbqOIdBO410AKU+BOPWZKoxessk='
WHERE
key_id = '9db7e518862e52a3438b4a35ef2d8e4f654b88f33d23ac1ea59ca60a844fb009'
AND (
token = 'lqNCUn8Z4v+OPJEERbqOIdBO410AKU+BOPWZKoxessk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)