UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gBRXCZap7bAWqj7t0CxByKMFugDQvm1XqkhJk+1Eus0='
WHERE
key_id = 'cc342e1d2f273f49bcf0fa432f6cf219751982f1a941ebefc84f15a7955287c5'
AND (
token = 'gBRXCZap7bAWqj7t0CxByKMFugDQvm1XqkhJk+1Eus0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)