SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '6598fea44ed77633fcbb19ba3ea82bd72fdc5df9895bc39ed2ce9845d6a954f8' 
  AND token = 'EkVVr6DId4/BjGd1mhhMagTHMB2bk3O3H6DnZ3yLsKg=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00045

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}