SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '42c8d3ccaa9ab5d1a20f3d9e4a62ccf7959b615d563463402f3a6df3abe733f6' 
  AND token = 'Z53NaB/ZDYOXtu09D33U8FS6+Q/kuADITGg/bpr++H4=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00047

JSON explain

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