SELECT 
  1 
FROM 
  cscart_aprillock_keys 
WHERE 
  key_id = '965624c753f6c846f16f43302ac3b80765680311e8109d57ee2737106cb1caec' 
  AND token = 'md2K1UGvzPA/T0mwb9H41K6dQ2WU/RomPp7Ugu83smE=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00031

JSON explain

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