UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CA1pJRBI+J0HzJkB+fFcHYId8Q/LWyBtCnHwMc9zAM0='
WHERE
key_id = '559cb1221160ebf4d0d9a3377cba46225ba8a0e5339f5a680c9cfa2cc01f5d37'
AND (
token = 'CA1pJRBI+J0HzJkB+fFcHYId8Q/LWyBtCnHwMc9zAM0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)