UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MPMGrt5F7/9rVIHTcS9QhTZXkc8rCY8M35dpP2Gry2c='
WHERE
key_id = 'f5397e6b17bd458e9777ddd8def15648b8b3c697717df57a99904b64dadccc39'
AND (
token = 'MPMGrt5F7/9rVIHTcS9QhTZXkc8rCY8M35dpP2Gry2c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)