UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hfpZEIJEYfvT6ZBVVrc2Fn8wLMGYPsJNfRPAZtCSKJE='
WHERE
key_id = '8b9b73321261b6c0d73df6f39d34d8997a0f9b2d4bb36f87b11de69110bc7118'
AND (
token = 'hfpZEIJEYfvT6ZBVVrc2Fn8wLMGYPsJNfRPAZtCSKJE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)