SELECT 
  1 
FROM 
  cscart_aprillock_keys 
WHERE 
  key_id = '86461322d46e9baac6b913e2b3c162b63f61f6ab9cbbe0b0173b1355035268e9' 
  AND token = 'fc98x/e4T2ZgzsXhb615h1RjJh4tVFize5K5J7qYc2U=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00039

JSON explain

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