SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '34874d579b24bd17d94882c71b0802a75f8f64614fb5f56d871a5b35d08763c0' 
  AND token = 'rsmNY87SmLZ9WKFmydhU3eRYGO8ASU9gVwGK0t7FHMo=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00019

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}