SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '0b8443551484674b331e47f8daa5405e3fe1f1b852a537f4c96724a4552dfa58' 
  AND token = 'Cziz+8bo3m5R7194KGpgi6PRDgw5uoO/hiXny22WISs=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00024

JSON explain

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