SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'fefa9bf148ac1a6ba8e751892f994a9b4ac9ac96d89bbe502eecd954a932cf4c' 
  AND token = 'ZCu4lJpROyWGcNOtNoT1wF94Y5KR2+4BAiy4MuIUt48=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00027

JSON explain

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