UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f6RoqEq0WOIWZtCGCZ69kITalx3Yeif3o+wiT85m72Q='
WHERE
key_id = '0c7f0a61477068e1a7956ee067eccd7a442cde5f61be778551180907ece7023c'
AND (
token = 'f6RoqEq0WOIWZtCGCZ69kITalx3Yeif3o+wiT85m72Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)