UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C7gICkv2oEWs9hBzrLYvrOvVCCXaSNlkjxTeKX7SAvA='
WHERE
key_id = 'e5e58a9603aa5d6f827867070c3ace681e7eda8ec324719a83b467981ae48d25'
AND (
token = 'C7gICkv2oEWs9hBzrLYvrOvVCCXaSNlkjxTeKX7SAvA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)